---
title: SAIF.Application.Claim.Legal SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Application.Claim.Legal
reference_type: embedded
---

# SAIF.Application.Claim.Legal SQL catalog

This page indexes all SQL statements and package calls documented for this library.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-insert-letter-request.md) | pk80001_LEGALNET.insertLetterRequest | StoredProc | N/A — Stored procedure | `LegalManagerBase` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-adjuster-code-list.md) | Retrieve active adjuster lookup list | Inline | ADP_EMPLOYEE | `clsAttorneyTableManager` |
| [SQL-003](SQL-003-alj-board-fj-person-list.md) | ALJ / Board / FJ person list | Inline | LEGAL_PERSON, LEGAL_PERSON_TYPE | `clsAttorneyTableManager` |
| [SQL-004](SQL-004-attorney-code-list.md) | SAIF attorney code list | Inline | ADP_EMPLOYEE, ATTORNEY_PROFILE | `clsAttorneyTableManager` |
| [SQL-005](SQL-005-hearing-location-code-list-attorney-tables.md) | Hearing location code list | Inline | HEARING_LOCATION_CODE | `clsAttorneyTableManager` |
| [SQL-006](SQL-006-policy-name-code-list.md) | Policy name code list | Inline | POLICY | `clsAttorneyTableManager` |
| [SQL-007](SQL-007-attorney-assignment-table-list.md) | Attorney-assignment maintenance table list | Inline | LEGAL_CODE_TABLE | `clsAttorneyTableManager` |
| [SQL-008](SQL-008-hearing-location-code-list-location-maintenance.md) | Hearing location code list | Inline | HEARING_LOCATION_CODE | `clsHearingLocationManager` |
| [SQL-009](SQL-009-legal-case-header.md) | pk80001_legalNet.getHeader | StoredProc | N/A — Stored procedure | `clsLegalData` |
| [SQL-010](SQL-010-other-firm-type-code-list.md) | Other-firm type code list | Inline | OTHER_FIRM_TYPE_CODE | `clsLegalPersonManager` |
| [SQL-011](SQL-011-person-maintenance-view-list.md) | Person-maintenance view code list | Inline | LEGAL_CODE_TABLE | `clsLegalPersonManager` |
| [SQL-012](SQL-012-legal-person-type-code-list.md) | Legal person type code list | Inline | LEGAL_PERSON_TYPE_CODE | `clsLegalPersonManager` |
| [SQL-013](SQL-013-outside-attorney-firm-list.md) | Opposing/outside attorney firm list | Inline | OTHER_FIRM, DUAL | `clsOtherPartiesManager` |
| [SQL-014](SQL-014-outside-attorney-person-list.md) | Opposing/outside attorney person list | Inline | LEGAL_PERSON, LEGAL_PERSON_TYPE, DUAL | `clsOtherPartiesManager` |
| [SQL-015](SQL-015-employer-insurer-firm-list.md) | Employer / insurer firm list | Inline | OTHER_FIRM, DUAL | `clsOtherPartiesManager` |
| [SQL-016](SQL-016-appeal-review-level-list.md) | Appeal number / review level list for a case | StringBuilder/concatenation | APPEAL, REVIEW_LEVEL_CODE, DUAL | `clsOutcomeManager` |
| [SQL-017](SQL-017-attorney-manager-email.md) | Assigned attorney's manager email | Inline scalar | DUAL (function body opaque) | `clsScheduleManager` |
| [SQL-018](SQL-018-legal-secretary-employee-id.md) | Legal secretary employee ID for an attorney | Inline scalar | ATTORNEY_PROFILE | `clsSummaryManager` |
| [SQL-019](SQL-019-allowed-case-status-list.md) | Allowed case status codes for the current case | StringBuilder/concatenation | CASE_STATUS_CODE | `clsUpdateCaseManager` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Security and authorization](../security-authorization.md)
- [Configuration](../configuration.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- SAIF.Application.Claim.Legal\LegalManagerBase.vb
- SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb
- SAIF.Application.Claim.Legal\clsHearingLocationManager.vb
- SAIF.Application.Claim.Legal\clsLegalPersonManager.vb
- SAIF.Application.Claim.Legal\clsLegalData.vb
- SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb
- SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb
- SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb
- SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb
- SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb